/*
Navicat SQL Server Data Transfer

Source Server         : LOCALHOST
Source Server Version : 110000
Source Host           : .:1433
Source Database       : AAACHAM2
Source Schema         : dbo

Target Server Type    : SQL Server
Target Server Version : 110000
File Encoding         : 65001

Date: 2014-04-29 18:12:46
*/


-- ----------------------------
-- Table structure for tb2557
-- ----------------------------
DROP TABLE [dbo].[tb2557]
GO
CREATE TABLE [dbo].[tb2557] (
[EmployeeID] varchar(20) NOT NULL ,
[DivisionID] varchar(20) NULL ,
[SalaryCoefficient] money NULL ,
[DutyCoefficient] money NULL ,
[TimeCoefficient] money NULL ,
[DepartmentID] varchar(20) NULL ,
[TeamID] varchar(20) NULL ,
[DutyID] varchar(20) NULL ,
[TaxObjectID] varchar(20) NULL ,
[EmployeeStatus] tinyint NULL ,
[Experience] nvarchar(100) NULL ,
[SuggestSalary] money NULL ,
[RecruitDate] datetime NULL ,
[RecruitPlace] nvarchar(250) NULL ,
[WorkDate] datetime NULL ,
[C01] money NULL ,
[C02] money NULL ,
[C03] money NULL ,
[C04] money NULL ,
[C05] money NULL ,
[C06] money NULL ,
[C07] money NULL ,
[C08] money NULL ,
[C09] money NULL ,
[C10] money NULL ,
[BaseSalary] money NULL ,
[InsuranceSalary] money NULL ,
[Salary01] money NULL ,
[Salary02] money NULL ,
[Salary03] money NULL ,
[Target01ID] varchar(20) NULL ,
[Target02ID] varchar(20) NULL ,
[Target03ID] varchar(20) NULL ,
[Target04ID] varchar(20) NULL ,
[Target05ID] varchar(20) NULL ,
[Target06ID] varchar(20) NULL ,
[Target07ID] varchar(20) NULL ,
[Target08ID] varchar(20) NULL ,
[Target09ID] varchar(20) NULL ,
[Target10ID] varchar(20) NULL ,
[TargetAmount01] money NULL ,
[TargetAmount02] money NULL ,
[TargetAmount03] money NULL ,
[TargetAmount04] money NULL ,
[TargetAmount05] money NULL ,
[TargetAmount06] money NULL ,
[TargetAmount07] money NULL ,
[TargetAmount08] money NULL ,
[TargetAmount09] money NULL ,
[TargetAmount10] money NULL ,
[LeaveDate] datetime NULL ,
[LoaCondID] varchar(20) NULL ,
[IsOtherDayPerMonth] tinyint NULL DEFAULT ((0)) ,
[FileID] varchar(20) NULL ,
[ApplyDate] datetime NULL ,
[BeginProbationDate] datetime NULL ,
[EndProbationDate] datetime NULL ,
[ProbationNote] nvarchar(250) NULL ,
[QuitJobID] varchar(20) NULL ,
[C11] money NULL ,
[C12] money NULL ,
[C13] money NULL 
)


GO

-- ----------------------------
-- Indexes structure for table tb2557
-- ----------------------------

-- ----------------------------
-- Primary Key structure for table tb2557
-- ----------------------------
ALTER TABLE [dbo].[tb2557] ADD PRIMARY KEY NONCLUSTERED ([EmployeeID])
GO
